using System;
using System.Collections;
using CE.Database;
/// <summary>
/// Summary description for UserProfileDB
/// </summary>
/// 
namespace CE.HomeRefinance
{
    public class HFPersonnelDB
    {
        public HFPersonnelDB()
        {
            //
            // TODO: Add constructor logic here
            //
        }

        public Int64 Insert(HFPersonnel personnel)
        {
            MyDatabase _db = new MyDatabase();
            Int64 _result = -1;
            string _spName = "[sprocHFPersonnelInsertUpdateSingleItem]";

            SortedList _sPara = new SortedList();

            #region Parameter
            _sPara.Add("@HFPersonnelID", personnel.HFPersonnelID);
            _sPara.Add("@HFID", personnel.HFID);
            _sPara.Add("@HFSalutation", personnel.HFSalutation);
            _sPara.Add("@HFFirstName", personnel.HFFirstName);
            _sPara.Add("@HFSurname", personnel.HFSurname);
            _sPara.Add("@HFNationality", personnel.HFNationality);
            _sPara.Add("@HFDOB", personnel.HFDOB);
            _sPara.Add("@HFIdType", personnel.HFIdType);
            _sPara.Add("@HFIdNo", personnel.HFIdNo);
            _sPara.Add("@HFIdIssDate", personnel.HFIdIssDate);
            _sPara.Add("@HFIdExpDate", personnel.HFIdExpDate);
            _sPara.Add("@HFIdIssCountry", personnel.HFIdIssCountry);
            _sPara.Add("@HFGender", personnel.HFGender);
            _sPara.Add("@HFMaritalStatus", personnel.HFMaritalStatus);
            _sPara.Add("@HFNoOfDependents", personnel.HFNoOfDependents);
            _sPara.Add("@HFHighestEdu", personnel.HFHighestEdu);
            _sPara.Add("@HFIsMainBorrower", personnel.HFIsMainBorrower);
            _sPara.Add("@HFJBPersonnelID", personnel.HFJBPersonnelID);
            _sPara.Add("@RefCEUserId", personnel.RefCEUserId);
            _sPara.Add("@IsMainPerson", personnel.IsMainPerson);
            _sPara.Add("@ViewedDetailId", personnel.ViewedDetailId);
            _sPara.Add("@Status", personnel.Status);
            _sPara.Add("@Info1", personnel.Info1);
            _sPara.Add("@Info2", personnel.Info2);
            _sPara.Add("@Info3", personnel.Info3);
            _sPara.Add("@Info4", personnel.Info4);
            _sPara.Add("@Info5", personnel.Info5);
            _sPara.Add("@Info6", personnel.Info6);
            _sPara.Add("@Info7", personnel.Info7);
            _sPara.Add("@Info8", personnel.Info8);
            _sPara.Add("@Info9", personnel.Info9);
            _sPara.Add("@Info10", personnel.Info10);
            _sPara.Add("@Info11", personnel.Info11);
            _sPara.Add("@Info12", personnel.Info12);
            _sPara.Add("@Info13", personnel.Info13);
            _sPara.Add("@Info14", personnel.Info14);
            _sPara.Add("@Info15", personnel.Info15);
            _sPara.Add("@Info16", personnel.Info16);
            _sPara.Add("@Info17", personnel.Info17);
            _sPara.Add("@Info18", personnel.Info18);
            _sPara.Add("@Info19", personnel.Info19);
            _sPara.Add("@Info20", personnel.Info20);
            #endregion

            _result = _db.ExecuteSP(_spName, _sPara);

            return _result;
        }

        public bool Update()
        {
            return true;
        }

        public bool Delete()
        {
            return true;
        }

    }
}